package com.anolesoft.amljmes.delivery.deliwebservice.mapper;

import com.anolesoft.amljmes.delivery.deliwebservice.dto.MesBzzScjljhDto;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface DeliWebMapper {
    /**
     * 插入封存防护计划
     */
    @Insert("INSERT INTO " +
            "MES_BZZ_FCFHJH(QUALIFIED_LABEL_NUMBER,expiration_time,PLAN_TYPE,C_USER,C_TIME,JIXING,TUHAO,PAIGONGHAO,JIAOFUCHEJIAN,JIESHOUCHEJIAN,JIAOFUSHUNXU,MINGCHENG,SHULIANG,FACTORY) " +
            "VALUES(#{qualifiedLabelNo},to_date(#{jlq},'yyyy/MM/dd'), 2,#{cuser},sysdate,#{model},#{partDrawingNo},#{pgh},#{jfcj},#{jscj},#{jfsx},#{partName},#{kyNum},#{fcode})")
    int insertFcfhjh(MesBzzScjljhDto mesBzzScjljhDto);
}
